Paul H · Director of Innovation and Design · Community Champion

Overview

Overview

Roles	Member
Badges	37

About Me

About Me

Analytics

361

Posts

1,601

Visits

1.9k

Points

Apr 13, 2015

Join Date

Apr 28, 2025

Last Active

Reactions

• Insightful 27

  27
• Vote Up 74

  74
• Awesome 25

  25

• Activity
• Posts15
• Comments346

• Re: Is it possible to pull the first initial from first name and last name from a contact list column?

  Paul H

  01/28/23
  Try this formula =LEFT([Employee Name]@row, 1) + RIGHT([Employee Name]@row, LEN([Employee Name]@row) - FIND(" ", [Employee Name]@row) + 1)
  1 ·

• Re: Document Builder - custom name for each file?

  Paul H

  03/31/22
  @Patrick Jones I use the same method Kimani suggests This is where you map it
  3 ·

• Re: Rolling 90 Day Formula

  Paul H

  04/01/22
  Try =IF(ISDATE(Start@row), IF(Start@row <= TODAY(90), IF(Start@row < TODAY(), 0, 1), 0))
  1 ·

• Re: Using data filter in Data Shuttle

  Paul H

  10/13/21
  Best I can do is give you an example of one I use. This only uploads part numbers that begin with 3, 4, or 5 and the part is not obsolete.
  1 ·

• Re: Index Collect Max | Get the most recent item based on Created Date

  Paul H

  01/12/23
  Add a helper checkbox column with this =IF([Created Date]@row = MAX(COLLECT([Created Date]:[Created Date], Auditor:Auditor, Auditor@row)), 1, 0) Then use this to get the lastest note =INDEX(COLLECT([…
  1 ·

Next